﻿using System.Configuration;
using System.Data;
using Microsoft.ApplicationBlocks.Data;

namespace Customs.Components.SLXNK
{
    public class DanhMucGiaCong
    {
        public static DataSet SelectAll()
        {
            string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString_SLXNK"].ConnectionString;
            string query = "SELECT * FROM SDanhMucGC ORDER BY ma_sp;";
            DataSet dt = SqlHelper.ExecuteDataset(connectionString, CommandType.Text, query);
            //DataRow row = dt.NewRow();
            //row["Ma_Nuoc"] = "   ";
            //row["Ten_Nuoc"] = "[Tất cả]";
            //dt.Rows.Add(row);
            return dt;
        }
    }
}